package com.henglian.verify.database

import androidx.room.*
import com.bj.disc.database.EventReq

@Dao
interface EventMsgDao {
    @Insert
     fun insertEventReq(req: EventReq)

    @Delete
    fun deleteEventReq(list:List<EventReq>)

    //SELECT * FROM EventReq GROUP BY eventTime, eventType HAVING COUNT(*) = 1 ORDER BY eventTime ASC LIMIT 100
    @Query("SELECT * FROM EventReq ORDER BY eventTime ASC LIMIT 100")
     fun getRecentData():  List<EventReq>?
    @Query("SELECT * FROM EventReq")
    fun getAllData():  List<EventReq>?

}
